1 Summary

This is a step by step log to combine survey results for the Southwark audit study

1.1 Data sources

Name Description URL (path)
feb_2021 oct18_N edited spreadsheet from CASS survey https://docs.google.com/spreadsheets/d/1WfDi7ojsyP_6uL2ts62kyQAxiwj4Xe9F/edit#gid=881012
oct18_N CASS survey results geopackages https://drive.google.com/file/d/1VV5nxWja2sA5jbKpHIgdVsE2Ie393QYH/view?usp=sharing
200601 New Polygons final upload New polygons (5 folders) https://drive.google.com/drive/folders/1dVyhXth5rYxvod10N16tDeF_Qvo5I8fz?usp=sharing
REDACTED_164_OKR Survey_WMT 2019 business base_191104 OKR survey (spreadsheet with point data) ~/Documents/SINDA_local/data_from_southwark/WMT OKR Business Survey 2019/REDACTED_164_OKR Survey_WMT 2019 business base_191104.xlsx

2 Load data

2.1 feb_2021 oct18_N

feb2021 <- read_xlsx("feb_2021 oct18_N.xlsx")

2.2 200601 New Polygons final upload

oct18 <- st_read("/Users/nicolas/Documents/R_GitHub/sind/oct18_N.gpkg")
## Reading layer `masterGJ' from data source `/Users/nicolas/Documents/R_GitHub/sind/oct18_N.gpkg' using driver `GPKG'
## Simple feature collection with 2515 features and 100 fields (with 458 geometries empty)
## geometry type:  MULTIPOLYGON
## dimension:      XY
## bbox:           xmin: 531305.5 ymin: 171277 xmax: 536322.5 ymax: 180434.8
## projected CRS:  unnamed

2.3 200601 New Polygons final upload

dir3
##   [1] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/56_90150002_b.gpkg"   
##   [2] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/46_15700001_b.gpkg"   
##   [3] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200015_b.gpkg"   
##   [4] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_200001_b.gpkg"     
##   [5] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200014_b.gpkg"   
##   [6] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/627_62400064_b.gpkg"  
##   [7] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/6_870_b.gpkg"         
##   [8] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200017_b.gpkg"   
##   [9] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/63_90320001_b.gpkg"   
##  [10] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/34_844_b.gpkg"        
##  [11] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/65_90320002_b.gpkg"   
##  [12] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/56_9015002_b.gpkg"    
##  [13] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/50_9080002_b.gpkg"    
##  [14] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/96_901780002_b.gpkg"  
##  [15] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/61_879_b.gpkg"        
##  [16] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200004_b.gpkg"   
##  [17] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/58_90120002_b.gpkg"   
##  [18] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/47_901570001_b.gpkg"  
##  [19] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/50_9080003_b.gpkg"    
##  [20] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200005_b.gpkg"   
##  [21] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/623_9030001_b.gpkg"   
##  [22] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/11_9040001_b.gpkg"    
##  [23] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/34_842_b.gpkg"        
##  [24] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/95_901780001_b.gpkg"  
##  [25] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/34_50001_b.gpkg"      
##  [26] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200016_b.gpkg"   
##  [27] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/47_1570001_b.gpkg"    
##  [28] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200008_b.gpkg"   
##  [29] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_200002_b.gpkg"     
##  [30] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200011_b.gpkg"   
##  [31] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400037_b.gpkg"
##  [32] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200013_b.gpkg"   
##  [33] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400032_b.gpkg"
##  [34] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400046_b.gpkg"
##  [35] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400033_b.gpkg"
##  [36] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400039_b.gpkg"
##  [37] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400044_b.gpkg"
##  [38] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400035_b.gpkg"
##  [39] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400029_b.gpkg"
##  [40] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400042_b.gpkg"
##  [41] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400045_b.gpkg"
##  [42] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400030_b.gpkg"
##  [43] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400041_b.gpkg"
##  [44] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400038_b.gpkg"
##  [45] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400031_b.gpkg"
##  [46] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400043_b.gpkg"
##  [47] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400040_b.gpkg"
##  [48] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400034_b.gpkg"
##  [49] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400024_b.gpkg"
##  [50] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400028_b.gpkg"
##  [51] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400027_b.gpkg"
##  [52] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400036_b.gpkg"
##  [53] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400023_b.gpkg"
##  [54] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400025_b.gpkg"
##  [55] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400026_b.gpkg"
##  [56] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200009_b.gpkg"   
##  [57] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200012_b.gpkg"   
##  [58] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200003_b.gpkg"   
##  [59] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200010_b.gpkg"   
##  [60] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200006_b.gpkg"   
##  [61] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/50_9080001_b.gpkg"    
##  [62] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200018_b.gpkg"   
##  [63] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/56_90120001_b.gpkg"   
##  [64] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/98_90200007_b.gpkg"   
##  [65] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/96_901780003_b.gpkg"  
##  [66] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/345_90790002_b.gpkg"  
##  [67] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/129_1021_b.gpkg"      
##  [68] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790016_b.gpkg"  
##  [69] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060014_b.gpkg"    
##  [70] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060004_b.gpkg"    
##  [71] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/36_9050002_b.gpkg"    
##  [72] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060013_b.gpkg"    
##  [73] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060015_b.gpkg"    
##  [74] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400035_b.gpkg" 
##  [75] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400047_b.gpkg" 
##  [76] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/278_7900001_b.gpkg"   
##  [77] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060007_b.gpkg"    
##  [78] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/123_90210001_b.gpkg"  
##  [79] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_14640001_b.gpkg"  
##  [80] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_14640007_b.gpkg"  
##  [81] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400015_b.gpkg" 
##  [82] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_14640003_b.gpkg"  
##  [83] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790013_b.gpkg"  
##  [84] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400024_b.gpkg" 
##  [85] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060012_b.gpkg"    
##  [86] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400026_b.gpkg" 
##  [87] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400048_b.gpkg" 
##  [88] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400045_b.gpkg" 
##  [89] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400027_b.gpkg" 
##  [90] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400034_b.gpkg" 
##  [91] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400011_b.gpkg" 
##  [92] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400010_b.gpkg" 
##  [93] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400046_b.gpkg" 
##  [94] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400028_b.gpkg" 
##  [95] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400043_b.gpkg" 
##  [96] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400032_b.gpkg" 
##  [97] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400023_b.gpkg" 
##  [98] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400019_b.gpkg" 
##  [99] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400042_b.gpkg" 
## [100] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_14640008_b.gpkg"  
## [101] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400019_b.gpkg"
## [102] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400031_b.gpkg" 
## [103] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400018_b.gpkg" 
## [104] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400022_b.gpkg"
## [105] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400020_b.gpkg"
## [106] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400021_b.gpkg"
## [107] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400041_b.gpkg" 
## [108] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400013_b.gpkg"
## [109] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_901040009_b.gpkg" 
## [110] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400016_b.gpkg"
## [111] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400017_b.gpkg"
## [112] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400018_b.gpkg"
## [113] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400015_b.gpkg"
## [114] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400014_b.gpkg"
## [115] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400011_b.gpkg"
## [116] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400010_b.gpkg"
## [117] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/40_9060001_b.gpkg"    
## [118] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_9010400012_b.gpkg"
## [119] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_901040006_b.gpkg" 
## [120] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790010_b.gpkg"  
## [121] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/282_7900005_b.gpkg"   
## [122] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_901040005_b.gpkg" 
## [123] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060002_b.gpkg"    
## [124] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060008_b.gpkg"    
## [125] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_901040007_b.gpkg" 
## [126] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_901040008_b.gpkg" 
## [127] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/435_901040004_b.gpkg" 
## [128] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060010_b.gpkg"    
## [129] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/35_9050001_b.gpkg"    
## [130] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790009_b.gpkg"  
## [131] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/443_1861_b.gpkg"      
## [132] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/443_1855_b.gpkg"      
## [133] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790014_b.gpkg"  
## [134] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300058_b.gpkg"
## [135] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790006_b.gpkg"  
## [136] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300057_b.gpkg"
## [137] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790008_b.gpkg"  
## [138] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790015_b.gpkg"  
## [139] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790011_b.gpkg"  
## [140] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300056_b.gpkg"
## [141] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/280_7900003_b.gpkg"   
## [142] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790017_b.gpkg"  
## [143] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300055_b.gpkg"
## [144] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_14640005_b.gpkg"  
## [145] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400036_b.gpkg" 
## [146] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060006_b.gpkg"    
## [147] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400025_b.gpkg" 
## [148] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790012_b.gpkg"  
## [149] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/281_7900004_b.gpkg"   
## [150] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_14640006_b.gpkg"  
## [151] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400012_b.gpkg" 
## [152] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400017_b.gpkg" 
## [153] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060003_b.gpkg"    
## [154] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400040_b.gpkg" 
## [155] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060011_b.gpkg"    
## [156] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_14640002_b.gpkg"  
## [157] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400021_b.gpkg" 
## [158] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400030_b.gpkg" 
## [159] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_14640009_b.gpkg"  
## [160] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300053_b.gpkg"
## [161] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400016_b.gpkg" 
## [162] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300054_b.gpkg"
## [163] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400020_b.gpkg" 
## [164] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400039_b.gpkg" 
## [165] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300052_b.gpkg"
## [166] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400038_b.gpkg" 
## [167] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_14640004_b.gpkg"  
## [168] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300048_b.gpkg"
## [169] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300050_b.gpkg"
## [170] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300046_b.gpkg"
## [171] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400033_b.gpkg" 
## [172] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300051_b.gpkg"
## [173] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300045_b.gpkg"
## [174] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300047_b.gpkg"
## [175] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300049_b.gpkg"
## [176] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/320_146400037_b.gpkg" 
## [177] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300039_b.gpkg"
## [178] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300042_b.gpkg"
## [179] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300043_b.gpkg"
## [180] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300044_b.gpkg"
## [181] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300041_b.gpkg"
## [182] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300036_b.gpkg"
## [183] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300040_b.gpkg"
## [184] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300033_b.gpkg"
## [185] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300034_b.gpkg"
## [186] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300037_b.gpkg"
## [187] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300038_b.gpkg"
## [188] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300035_b.gpkg"
## [189] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300032_b.gpkg"
## [190] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300030_b.gpkg"
## [191] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300031_b.gpkg"
## [192] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/786_1861_b.gpkg"      
## [193] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/707_901150009_b.gpkg" 
## [194] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/810_1855_b.gpkg"      
## [195] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/829_314_b.gpkg"       
## [196] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/707_901150010_b.gpkg" 
## [197] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/345_90790001_b.gpkg"  
## [198] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300027_b.gpkg"
## [199] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300028_b.gpkg"
## [200] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300029_b.gpkg"
## [201] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060016_b.gpkg"    
## [202] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/120_901001_b.gpkg"    
## [203] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300026_b.gpkg"
## [204] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/279_7900002_b.gpkg"   
## [205] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300023_b.gpkg"
## [206] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300024_b.gpkg"
## [207] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/113_90200019_b.gpkg"  
## [208] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/707_901150007_b.gpkg" 
## [209] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060005_b.gpkg"    
## [210] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300020_b.gpkg"
## [211] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/42_9060009_b.gpkg"    
## [212] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300021_b.gpkg"
## [213] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/707_901150008_b.gpkg" 
## [214] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/173_2600004_b.gpkg"   
## [215] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300022_b.gpkg"
## [216] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/173_2600006_b.gpkg"   
## [217] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/173_2600005_b.gpkg"   
## [218] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/572_90230008_b.gpkg"  
## [219] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/200_619_b.gpkg"       
## [220] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/571_90510001_b.gpkg"  
## [221] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/570_90400001_b.gpkg"  
## [222] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300018_b.gpkg"
## [223] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300017_b.gpkg"
## [224] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300016_b.gpkg"
## [225] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/569_90250025_b.gpkg"  
## [226] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300019_b.gpkg"
## [227] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/346_90790005_b.gpkg"  
## [228] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/345_90790003_b.gpkg"  
## [229] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300015_b.gpkg"
## [230] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/345_90790004_b.gpkg"  
## [231] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300014_b.gpkg"
## [232] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300012_b.gpkg"
## [233] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300013_b.gpkg"
## [234] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300011_b.gpkg"
## [235] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300010_b.gpkg"
## [236] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_901030008_b.gpkg" 
## [237] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_901030009_b.gpkg" 
## [238] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_9010300025_b.gpkg"
## [239] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_901030007_b.gpkg" 
## [240] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_901030005_b.gpkg" 
## [241] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_901030003_b.gpkg" 
## [242] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_901030006_b.gpkg" 
## [243] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_901030004_b.gpkg" 
## [244] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_901030002_b.gpkg" 
## [245] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/431_1030001_b.gpkg"   
## [246] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/450_10500001_b.gpkg"  
## [247] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/565_901370001_b.gpkg" 
## [248] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/560_902390001_b.gpkg" 
## [249] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/702_982_b.gpkg"       
## [250] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/558_90540001_b.gpkg"  
## [251] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/703_966_b.gpkg"       
## [252] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/704_950_b.gpkg"       
## [253] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/701_984_b.gpkg"       
## [254] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/700_989_b.gpkg"       
## [255] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/449_1050002_b.gpkg"   
## [256] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/443_1849_b.gpkg"      
## [257] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/441_1844_b.gpkg"      
## [258] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/707_901150006_b.gpkg" 
## [259] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/442_1846_b.gpkg"      
## [260] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/465_901280001_b.gpkg" 
## [261] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/440_1840_b.gpkg"      
## [262] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/707_901150005_b.gpkg" 
## [263] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/461_901240001_b.gpkg" 
## [264] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/707_901150003_b.gpkg" 
## [265] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/459_901230001_b.gpkg" 
## [266] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/794_352_b.gpkg"       
## [267] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/698_1055_b.gpkg"      
## [268] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/456_901220001_b.gpkg" 
## [269] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/458_901230002_b.gpkg" 
## [270] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/699_992_b.gpkg"       
## [271] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/997_994_b.gpkg"       
## [272] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/696_997_b.gpkg"       
## [273] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/694_938_b.gpkg"       
## [274] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/696_2600001_b.gpkg"   
## [275] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/695_2600002_b.gpkg"   
## [276] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/693_920_b.gpkg"       
## [277] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/448_901050001_b.gpkg" 
## [278] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/707_901150002_b.gpkg" 
## [279] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/813_344_b.gpkg"       
## [280] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/692_925_b.gpkg"       
## [281] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/730_357_b.gpkg"       
## [282] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/438_901040003_b.gpkg" 
## [283] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/437_901040002_b.gpkg" 
## [284] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/436_901040001_b.gpkg" 
## [285] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/715_339_b.gpkg"       
## [286] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/327_90670001_b.gpkg"  
## [287] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/707_901150004_b.gpkg" 
## [288] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/707_307_b.gpkg"       
## [289] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/173_2600008_b.gpkg"   
## [290] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/173_2600007_b.gpkg"   
## [291] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/692_913_b.gpkg"       
## [292] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/691_2700001_b.gpkg"   
## [293] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/556_90830001_b.gpkg"  
## [294] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/554_901040004_b.gpkg" 
## [295] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/690_1030002_b.gpkg"   
## [296] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/551_901050004_b.gpkg" 
## [297] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/555_90840001_b.gpkg"  
## [298] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/549_901050003_b.gpkg" 
## [299] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/432_901030001_b.gpkg" 
## [300] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/532_9100002_b.gpkg"   
## [301] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/361_90850001_b.gpkg"  
## [302] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/460_1888_b.gpkg"      
## [303] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/547_901250002_b.gpkg" 
## [304] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/548_901240001_b.gpkg" 
## [305] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/547_901250001_b.gpkg" 
## [306] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/89_90890001_b.gpkg"   
## [307] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/539_90290001_b.gpkg"  
## [308] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/538_902400002_b.gpkg" 
## [309] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/457_1879_b.gpkg"      
## [310] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/439_1810_b.gpkg"      
## [311] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/537_902400001_b.gpkg" 
## [312] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/355_1577_b.gpkg"      
## [313] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/370_9100001_b.gpkg"   
## [314] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/353_1562_b.gpkg"      
## [315] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/354_1566_b.gpkg"      
## [316] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/536_901110001_b.gpkg" 
## [317] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/534_902530001_b.gpkg" 
## [318] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/533_901970001_b.gpkg" 
## [319] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/535_902530002_b.gpkg" 
## [320] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/478_901650002_b.gpkg" 
## [321] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/477_901650001_b.gpkg" 
## [322] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/545_901490001_b.gpkg" 
## [323] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/284_7900007_b.gpkg"   
## [324] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/285_7900008_b.gpkg"   
## [325] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/286_7900009_b.gpkg"   
## [326] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/577_901150001_b.gpkg" 
## [327] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/425_96900001_b.gpkg"  
## [328] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/587_90470006_b.gpkg"  
## [329] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/578_90960001_b.gpkg"  
## [330] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/283_7900006_b.gpkg"   
## [331] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/601_90610003_b.gpkg"  
## [332] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/589_90940006_b.gpkg"  
## [333] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/689_90790021_b.gpkg"  
## [334] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/607_90780001_b.gpkg"  
## [335] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/611_90450007_b.gpkg"  
## [336] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/608_902340001_b.gpkg" 
## [337] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/590_90940005_b.gpkg"  
## [338] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/687_90610002_b.gpkg"  
## [339] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/606_90610002_b.gpkg"  
## [340] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/598_90470004_b.gpkg"  
## [341] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/603_902930001_b.gpkg" 
## [342] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/655_90460003_b.gpkg"  
## [343] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/613_901840001_b.gpkg" 
## [344] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/662_90150003_b.gpkg"  
## [345] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/653_90450001_b.gpkg"  
## [346] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/621_90320004_b.gpkg"  
## [347] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/666_90130001_b.gpkg"  
## [348] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/7_9030002_b.gpkg"     
## [349] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/668_90730001_b.gpkg"  
## [350] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/657_901670001_b.gpkg" 
## [351] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/663_901480001_b.gpkg" 
## [352] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/659_901580001_b.gpkg" 
## [353] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/617_90160005_b.gpkg"  
## [354] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/581_90480002_b.gpkg"  
## [355] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/686_901610001_b.gpkg" 
## [356] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/52_9080001_b.gpkg"    
## [357] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/687_90450002_b.gpkg"  
## [358] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/76_951_b.gpkg"        
## [359] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/619_90440001_b.gpkg"  
## [360] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/61_872_b.gpkg"        
## [361] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/674_90040001_b.gpkg"  
## [362] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/686_901660001_b.gpkg" 
## [363] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/31_9050003_b.gpkg"    
## [364] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/665_90470001_b.gpkg"  
## [365] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/616_90450006_b.gpkg"  
## [366] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/688_90450003_b.gpkg"  
## [367] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/686_90450004_b.gpkg"  
## [368] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/591_90940004_b.gpkg"  
## [369] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/690_90940001_b.gpkg"  
## [370] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/602_90460004_b.gpkg"  
## [371] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/588_90940003_b.gpkg"  
## [372] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/594_90470005_b.gpkg"  
## [373] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/592_90940002_b.gpkg"  
## [374] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/618_90450005_b.gpkg"  
## [375] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/671_90610001_b.gpkg"  
## [376] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/687_1590_b.gpkg"      
## [377] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/89_90170002_B.gpkg"   
## [378] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/209_90420003_B.gpkg"  
## [379] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/80_90160001_B.gpkg"   
## [380] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250014_B.gpkg"  
## [381] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/190_90320001_B.gpkg"  
## [382] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/240_90460002_B.gpkg"  
## [383] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/245_90470001_B.gpkg"  
## [384] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/260_6000002_B.gpkg"   
## [385] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/273_6100010_B.gpkg"   
## [386] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/271_6100008_B.gpkg"   
## [387] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/259_6000001_B.gpkg"   
## [388] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/133_90230006_B.gpkg"  
## [389] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/275_6100012_B.gpkg"   
## [390] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/133_90230004_B.gpkg"  
## [391] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/263_6000005_B.gpkg"   
## [392] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250008_B.gpkg"  
## [393] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250019_B.gpkg"  
## [394] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/195_90330001_B.gpkg"  
## [395] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/246_90470002_B.gpkg"  
## [396] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250010_B.gpkg"  
## [397] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250024_B.gpkg"  
## [398] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/87_90160004_B.gpkg"   
## [399] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250005_B.gpkg"  
## [400] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/269_6100006_B.gpkg"   
## [401] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/261_6000003_B.gpkg"   
## [402] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/196_90360001_B.gpkg"  
## [403] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250018_B.gpkg"  
## [404] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/133_90230002_B.gpkg"  
## [405] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/88_90170001_B.gpkg"   
## [406] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250004_B.gpkg"  
## [407] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/149_90230003_B.gpkg"  
## [408] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/239_90460001_B.gpkg"  
## [409] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/211_90420004_B.gpkg"  
## [410] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/265_6100002_B.gpkg"   
## [411] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/210_90420002_B.gpkg"  
## [412] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250022_B.gpkg"  
## [413] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/181_90300001_B.gpkg"  
## [414] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/270_6100007_B.gpkg"   
## [415] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250007_B.gpkg"  
## [416] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250023_B.gpkg"  
## [417] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/201_3900001_B.gpkg"   
## [418] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/81_90160002_B.gpkg"   
## [419] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/252_90550001_B.gpkg"  
## [420] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/133_90230001_B.gpkg"  
## [421] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/77_90150001_B.gpkg"   
## [422] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/268_6100005_B.gpkg"   
## [423] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/266_6100003_B.gpkg"   
## [424] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/267_6100004_B.gpkg"   
## [425] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/276_6100013_B.gpkg"   
## [426] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250009_B.gpkg"  
## [427] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/149_90230001_B.gpkg"  
## [428] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/133_90230005_B.gpkg"  
## [429] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/133_90230003_B.gpkg"  
## [430] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/274_6100011_B.gpkg"   
## [431] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/262_6000004_B.gpkg"   
## [432] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/272_6100009_B.gpkg"   
## [433] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/133_90230007_B.gpkg"  
## [434] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250016_B.gpkg"  
## [435] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/214_90420005_B.gpkg"  
## [436] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/86_90160003_B.gpkg"   
## [437] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250011_B.gpkg"  
## [438] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/277_6100014_B.gpkg"   
## [439] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250021_B.gpkg"  
## [440] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250003_B.gpkg"  
## [441] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/197_90360002_B.gpkg"  
## [442] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/248_90480001_B.gpkg"  
## [443] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250020_B.gpkg"  
## [444] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250012_B.gpkg"  
## [445] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/247_90470003_B.gpkg"  
## [446] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250001_B.gpkg"  
## [447] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250013_B.gpkg"  
## [448] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250017_B.gpkg"  
## [449] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250006_B.gpkg"  
## [450] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/208_90420001_B.gpkg"  
## [451] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/161_90250002_B.gpkg"  
## [452] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/164_90250015_B.gpkg"  
## [453] "/var/folders/nw/3_7tcnfd3sd0mzpcjkxljc5h0000gq/T//RtmpvwUVLZ/264_6100001_B.gpkg"
#grep("90220001", dir3)
#sapply(gpkg, function(y) "90220001" %in% y)
# remove lists with nrow > 0
gpkg1 <- gpkg[sapply(gpkg, nrow) > 0]
#unlist(gpkg1, recursive = F)
# create a new variable with CRS
gpkg2 <- lapply(gpkg1, function(x) within(x, crs <- unlist(st_crs(x), recursive = F)))
# select BNG 
gpkg21 <- rbindlist(gpkg2, use.names=FALSE) %>%
  filter(crs == "OSGB 1936 / British National Grid") %>%
  st_sf() %>%
  select(fid)
# select WGS 84
gpkg22 <- rbindlist(gpkg2, use.names=FALSE) %>%
  filter(crs == "WGS 84") %>%
  st_sf() %>% 
  st_set_crs(value = 4326) %>%  # assign original projection
  st_transform(27700) %>% # transform to join all
  select(fid)
## Warning: st_crs<- : replacing crs does not reproject data; use st_transform for
## that
# select != BNG | != 4326
gpkg23 <- rbindlist(gpkg2, use.names=FALSE) %>%
  filter(crs != "OSGB 1936 / British National Grid") %>%
  filter(crs != "WGS 84") %>%
  st_sf() %>%
  select(fid)
pol <- gpkg21 %>%
  rbind(gpkg22)
pol <- pol %>%
  rbind(gpkg23)

2.4 REDACTED_164_OKR Survey_WMT 2019 business base_191104

okr <- read_excel("~/Documents/SINDA_local/data_from_southwark/WMT OKR Business Survey 2019/REDACTED_164_OKR Survey_WMT 2019 business base_191104.xlsx", 
    col_types = c("text", "numeric", "text", 
        "text", "text", "text", "text", "numeric", 
        "text", "text", "text", "text", "text", 
        "text", "text", "text", "text", "text", 
        "text", "text", "text", "text", "text", 
        "text", "text", "numeric", "numeric", 
        "numeric", "numeric", "text", "text", 
        "text", "text", "text", "text", "text", 
        "text", "numeric", "text", "numeric", 
        "text", "text", "text", "numeric", 
        "numeric", "numeric", "numeric"))

3 Explore data

3.1 feb2021

glimpse(feb2021)
## Rows: 2,548
## Columns: 87
## $ query_code                 <dbl> 346, NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ `1_Surveyor_Nickname`      <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "N…
## $ `2_Map_sheet_number`       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 13…
## $ `3_Functional_Unit_Co`     <dbl> 90790005, 90790002, 90790003, 90790004, 90…
## $ `5_11_Name_of_organis`     <chr> "(unknown)", "(unknown)", "(unknown)", "(u…
## $ `6_12_Description_of_`     <chr> "(food production / storage)", "(food prod…
## $ `7_13_When_was_the_or`     <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `8_14_Do_you_regard_t`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `9_15_If_no_what_type`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `10_16_If_other_pleas`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `12_21_Total_number_o`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `13_22_Observed_or_Ve`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `14_23_How_many_FTEs_`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `15_24_Observed_or_Ve`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `16_25_Is_the_organis`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `17_26_How_many_peopl`     <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `19_31_Floor_levels_t`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `20_32_How_many_store`     <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `21_33_Unit_size_Inse`     <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `22_34_Square_metres_`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `23_35_Observed_or_Ve`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `24_36_Predominant_he`     <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `25_37_Premises_type_`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "r…
## $ `26_38_If_other_pleas`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `27_39_Type_of_associ`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `28_310_Car_parking_S`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `29_311_Goods_access_`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `30_312_Are_these_pre`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `31_313_If_premises_a`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `32_314_When_did_the_`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `33_315_Is_the_premis`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `34_316_If_rentedleas`     <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `35_317_Will_the_leas`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `37_41_Is_the_localit`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `38_42_If_so_why_sele`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `39_43_If_locality_is`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `40_44_What_is_your_v`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `41_45_What_are_the_t`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `42_46_Where_are_the_`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `43_47_Where_are_the_`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `44_48_Is_the_organis`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `45_49_Does_the_organ`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `46_410_If_yes_where_`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `47_411_If_yes_when`       <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `48_412_If_yes_why`        <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `49_413_Are_the_organ`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `50_414_If_yes_please`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `51_415_Are_you_aware`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `52_416_If_yes_how_ha`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `53_417_If_other_plea`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `54_418_What_is_your_`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `56_51_Contact_willin`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `57_52_Name_of_contac`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `58_53_Contact_teleph`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `59_54_Contact_email_`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `60_55_Organisation_t`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "0…
## $ `61_56_Organisation_w`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "v…
## $ `62_57_Organisation_e`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `63_58_Street_name_eg`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "S…
## $ `64_59_Street_number_`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `65_510_Postcode_Incl`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "S…
## $ `66_511_Unit_number_i`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "1…
## $ `68_61_Additional_not`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "A…
## $ `69_62_Internal_photo`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `71_71_Would_the_acti`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "n…
## $ lat_72_72_Location         <dbl> 51.49604, NA, NA, NA, NA, NA, NA, NA, NA, …
## $ long_72_72_Location        <dbl> -0.068400, NA, NA, NA, NA, NA, NA, NA, NA,…
## $ accuracy_72_72_Location    <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, 4,…
## $ `73_73_External_photo`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "h…
## $ `74_74_SIC_Code`           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ `76_76_Notes_on_any_o`     <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ sD_RS_field_1              <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ sD_RS_6_12_Description_of_ <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "2…
## $ Polygon                    <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "Y…
## $ mb_comment                 <chr> "Industrial use in arches and yard. To che…
## $ comment_1                  <chr> "on site survey", NA, NA, NA, NA, NA, NA, …
## $ comment_2                  <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ comment_3                  <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ pX                         <dbl> 534184.2, NA, NA, NA, NA, NA, NA, NA, NA, …
## $ pY                         <chr> "179224", NA, NA, NA, NA, NA, NA, NA, NA, …
## $ name                       <chr> "Max", "Max", "Max", "Max", "Max", "Max", …
## $ query_resolved             <chr> "yes", "yes", "yes", "yes", "yes", "yes", …
## $ action_spatial             <chr> "FUC polygon created", "FUC polygon create…
## $ action_spreadsheet         <chr> "FUC added to record", "FUC added to recor…
## $ parcels_actions            <chr> "None", "None", "None", "None", NA, NA, NA…
## $ action_other               <chr> "Desktop survey undertaken", "Desktop surv…
## $ resolution_details         <chr> "desktop survey established arches used fo…
options(scipen = 999)

3.2 oct18

glimpse(oct18)
## Rows: 2,515
## Columns: 101
## $ field_1.x                       <dbl> 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12…
## $ ec5_uuid                        <chr> "09e71ebd-b430-421a-9866-21ebdbcc7462…
## $ created_at                      <dttm> 2019-10-13 23:11:31, 2019-10-03 16:3…
## $ title                           <chr> "Neil C 73 7300002", "Neil 52 6240006…
## $ X1_Surveyor_Nickname            <chr> "Neil C", "Neil", "Neil", "Neil", "Ne…
## $ X2_Map_sheet_number             <dbl> 73, 52, 52, 52, 52, 52, 52, 52, 52, 5…
## $ X3_Functional_Unit_Co           <dbl> 7300002, 62400060, 62400059, 62400058…
## $ X5_11_Name_of_organis           <chr> "East Dulwich Car Wash", "Alex Bartsc…
## $ X6_12_Description_of_           <chr> "Car washing", "Photographer", "Scree…
## $ X7_13_When_was_the_or           <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X8_14_Do_you_regard_t           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X9_15_If_no_what_type           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X10_16_If_other_pleas           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X12_21_Total_number_o           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X13_22_Observed_or_Ve           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X14_23_How_many_FTEs_           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X15_24_Observed_or_Ve           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X16_25_Is_the_organis           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X17_26_How_many_peopl           <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X19_31_Floor_levels_t           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X20_32_How_many_store           <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X21_33_Unit_size_Inse           <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X22_34_Square_metres_           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X23_35_Observed_or_Ve           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X24_36_Predominant_he           <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X25_37_Premises_type_           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X26_38_If_other_pleas           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X27_39_Type_of_associ           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X28_310_Car_parking_S           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X29_311_Goods_access_           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X30_312_Are_these_pre           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X31_313_If_premises_a           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X32_314_When_did_the_           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X33_315_Is_the_premis           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X34_316_If_rentedleas           <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X35_317_Will_the_leas           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X37_41_Is_the_localit           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X38_42_If_so_why_sele           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X39_43_If_locality_is           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X40_44_What_is_your_v           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X41_45_What_are_the_t           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X42_46_Where_are_the_           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X43_47_Where_are_the_           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X44_48_Is_the_organis           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X45_49_Does_the_organ           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X46_410_If_yes_where_           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X47_411_If_yes_when             <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X48_412_If_yes_why              <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X49_413_Are_the_organ           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X50_414_If_yes_please           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X51_415_Are_you_aware           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X52_416_If_yes_how_ha           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X53_417_If_other_plea           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X54_418_What_is_your_           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X56_51_Contact_willin           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X57_52_Name_of_contac           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X58_53_Contact_teleph           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X59_54_Contact_email_           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X60_55_Organisation_t           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X61_56_Organisation_w           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X62_57_Organisation_e           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X63_58_Street_name_eg           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X64_59_Street_number_           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X65_510_Postcode_Incl           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X66_511_Unit_number_i           <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X68_61_Additional_not           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X69_62_Internal_photo           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X71_71_Would_the_acti           <chr> "no", "no", "no", NA, NA, "no", "no",…
## $ lat_72_72_Location              <dbl> 51.4577, NA, NA, NA, NA, NA, NA, NA, …
## $ long_72_72_Location             <dbl> -0.075864, NA, NA, NA, NA, NA, NA, NA…
## $ accuracy_72_72_Location         <dbl> 4, NA, NA, NA, NA, NA, NA, NA, NA, NA…
## $ X73_73_External_photo           <chr> "https://five.epicollect.net/api/medi…
## $ X74_74_SIC_Code                 <chr> "81299", NA, NA, NA, NA, NA, NA, NA, …
## $ X75_75_Site_ID                  <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ X76_76_Notes_on_any_o           <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ sD_RS_field_1                   <dbl> NA, NA, NA, NA, NA, 1, NA, NA, NA, NA…
## $ sD_RS_6_12_Description_of_...10 <chr> "Car washing", "Artist", "Artist", "A…
## $ Polygon                         <chr> "Yes", "Yes", "Yes", "Yes", "Yes", "Y…
## $ b_sheet                         <int> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ FUC                             <int> 7300002, 62400060, 62400059, 62400058…
## $ FUC_s                           <chr> "7300002", "62400060", "62400059", "6…
## $ field_1.y                       <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ query_code                      <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ fuc_2                           <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ lat                             <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ long                            <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ sheet_no                        <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ sheet_no_2                      <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ mb_note_no                      <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ mb_comment                      <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ comment_1                       <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ comment_2                       <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ comment_3                       <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ description_M                   <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ description_updated             <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ category                        <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ Map.Sheet.Number                <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ Latitude_mi                     <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ Longitude_mi                    <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ Note_mi                         <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, N…
## $ geom                            <MULTIPOLYGON [m]> MULTIPOLYGON (((533784.5…

3.3 pol

glimpse(pol)
## Rows: 310
## Columns: 2
## $ fid      <chr> "15700001", "90200015", "90200001", "90200014", "62400064", …
## $ geometry <POLYGON [m]> POLYGON ((531583.3 179339.5..., POLYGON ((532081.4 1…
tmap_mode("view")
## tmap mode set to interactive viewing
qtm(pol, fill = "tomato")

3.4 okr

glimpse(okr)
## Rows: 943
## Columns: 47
## $ Source...1                                             <chr> "2019", "2019"…
## $ `Business count`                                       <dbl> 1, 1, 1, 1, 1,…
## $ `Business within MOB`                                  <chr> "I", "I", NA, …
## $ `Multiple buildings`                                   <chr> NA, NA, NA, NA…
## $ `Multi-occupier building`                              <chr> NA, NA, NA, NA…
## $ Source...6                                             <chr> NA, NA, "152",…
## $ codex                                                  <chr> "MOB", "MOB", …
## $ Join                                                   <dbl> NA, NA, 713, 0…
## $ Xcoord                                                 <chr> "MOB", "MOB", …
## $ Ycoord                                                 <chr> "MOB", "MOB", …
## $ AAP                                                    <chr> "Y", "Y", "Y",…
## $ `Site allocation`                                      <chr> "OKR18", "OKR1…
## $ `Sub-area`                                             <chr> "4", "4", "3",…
## $ `Business name`                                        <chr> "1666 Fire", "…
## $ `Street no`                                            <chr> NA, NA, "52-56…
## $ Unit                                                   <chr> NA, NA, NA, NA…
## $ Floor                                                  <chr> NA, NA, "0", "…
## $ Street                                                 <chr> "Daisy Busines…
## $ `2015-2019`                                            <chr> "New", "Remain…
## $ Notes_on_C                                             <chr> NA, NA, NA, NA…
## $ `Business activity`                                    <chr> "Technical ser…
## $ `SIC CODE`                                             <chr> "749", "181", …
## $ Sector                                                 <chr> "M Services: p…
## $ `Building use category`                                <chr> NA, NA, "Emplo…
## $ `Building type`                                        <chr> "3_Pre-1945 fa…
## $ `Actual number of employee`                            <dbl> NA, NA, 9, 2, …
## $ `Estimated number of employee`                         <dbl> 4, 5, 0, 0, 0,…
## $ `TOTAL NUMBER OF EMPLOYEE`                             <dbl> 4, 5, 9, 2, 31…
## $ `employees for density`                                <dbl> NA, NA, 9, 2, …
## $ `GF multiplier`                                        <chr> NA, NA, "1", "…
## $ `UF multiplier`                                        <chr> NA, NA, "0.3",…
## $ `B multiplier`                                         <chr> NA, NA, "0", "…
## $ Long_surve                                             <chr> NA, NA, "N", "…
## $ `GF Floorspace area`                                   <chr> NA, NA, "302.5…
## $ `UF Floorspace`                                        <chr> NA, NA, "90.75…
## $ `Total floorspace`                                     <chr> NA, NA, "393.2…
## $ `Total floorspace post VOA+15% analysis`               <chr> NA, NA, "415.0…
## $ density                                                <dbl> NA, NA, 43.694…
## $ `2.07 What % of employees of employees live locally? ` <chr> NA, NA, NA, NA…
## $ ...40                                                  <dbl> NA, NA, NA, NA…
## $ ...41                                                  <chr> NA, NA, NA, NA…
## $ ...42                                                  <chr> NA, NA, NA, NA…
## $ ...43                                                  <chr> NA, NA, NA, NA…
## $ ...44                                                  <dbl> NA, NA, NA, NA…
## $ ...45                                                  <dbl> NA, NA, NA, NA…
## $ ...46                                                  <dbl> NA, NA, NA, NA…
## $ ...47                                                  <dbl> NA, NA, NA, NA…

4 Edit data

4.1 feb2021

Identify what sD_RS_field_1 is - delete if not required for anything
Count NA in sD_RS_field_1

feb2021 %>%
  filter(is.na(sD_RS_field_1)) %>%
  nrow()
## [1] 2447

2447 out of 2548 are NA

feb2021 %>%
  distinct(sD_RS_field_1)

Combine Comments 1, 2 and 3 into one column with comments separated by semicolons

feb2021e <- feb2021 %>%
  mutate(comments = paste(comment_1, comment_2, comment_3, sep = "; "))

Note that under ‘action spatial’ is a category ‘FUC polygon needs deleting’ - delete these polygons and then delete these records Data frame with “FUC polygon needs deleting”

df_pnd <- feb2021e %>%
  filter(action_spatial == "FUC polygon needs deleting") %>%
  select("3_Functional_Unit_Co")
df_pnd

Remove values with “FUC polygon needs deleting”

feb2021e <- feb2021e %>%
  filter(is.na(action_spatial) | action_spatial != "FUC polygon needs deleting")

Remove values with “FUC polygon needs deleting” from oct18

oct18 <- oct18 %>%
  filter(!X3_Functional_Unit_Co %in% df_pnd$`3_Functional_Unit_Co`)

I assume we can delete those which do not have an FUC
Remove values where 3_Functional_Unit_Co == 0

feb2021e %>%
  filter(is.na(`3_Functional_Unit_Co`)) %>%
  nrow()
## [1] 38
feb2021e <- feb2021e %>%
  filter(!is.na(`3_Functional_Unit_Co`))

Select unique 3_Functional_Unit_Co

feb2021e1 <- feb2021e %>%
  distinct(`3_Functional_Unit_Co`, .keep_all = TRUE)

feb2021e1 has 2486 obs with 3_Functional_Unit_Co unique values

4.2 oct18

Join oct18 with 200601 New Polygons final upload (pol)
pol is more accurate than oct18 therefore if FUC are repeated pol features are kept

  1. Create vector with pol fid (or FUC)
pol_fid <- pol %>%
  pull(fid)
  1. Reduce oct variable to fid and geometry and filter %in% pol_fid (pol features are kept)
# reduce oct variable to fid and geometry
pol18 <- oct18 %>%
  select(X3_Functional_Unit_Co) %>%
  rename(fid = X3_Functional_Unit_Co,
         geometry = geom) %>%
  st_set_crs(value = 27700) %>%
  filter(!fid %in% pol_fid)
## Warning: st_crs<- : replacing crs does not reproject data; use st_transform for
## that
head(pol18)
pol18

Simple feature collection with 2429 features and 1 field (with 452 geometries empty)

pol181 <- pol18[!st_is_empty(pol18),,drop=FALSE]

Remove duplicated fid and geometry

pol181 <- pol181 %>% 
  unique.data.frame()
  1. Join
pol %>%
  filter(fid == 90220001) 
## Warning in `[<-.data.frame`(`*tmp*`, is_list, value = list(`2` = "<s_GEOMET>")):
## replacement element 1 has 1 row to replace 0 rows
# Remove duplicated fid and geometry in pol
pol1 <- pol %>% 
  unique.data.frame()
pol_all <- rbind(pol181, pol1)
qtm(pol_all, fill = "tomato")

4.3 Merge all

Merge pol_all (oct18 and New Polygons) with feb2021 table by FUC

object n
pol_all 2273
feb2021e 2486
mall <- pol_all %>%
  mutate(fid = as.numeric(fid)) %>%
  left_join(feb2021e1, by = c(fid = "3_Functional_Unit_Co"), keep = TRUE) %>%
  st_make_valid() %>%
  st_collection_extract() # convert from type GEOMETRY to type MULTIPOLYGON
qtm(mall, fill = "tomato")
vfid <- pol_all %>%
  pull(fid)

View rows in feb2021 without match (60 rows with query code and no match)

feb2021e1 %>%
  filter(!`3_Functional_Unit_Co` %in% vfid) %>%
  filter(!is.na(query_code)) %>%
  select(1,4,81:88)

Check in “200601 New Polygons final upload” folder

Query 320 : the file exist but is empty

ch1 <- st_read("/Users/nicolas/Documents/R_GitHub/sind/200601 New Polygons final upload/Neil/Neil Tower Workshops/320_146400035_b.gpkg")
## Reading layer `320_146400035_b' from data source `/Users/nicolas/Documents/R_GitHub/sind/200601 New Polygons final upload/Neil/Neil Tower Workshops/320_146400035_b.gpkg' using driver `GPKG'
## Simple feature collection with 0 features and 0 fields
## bbox:           xmin: NA ymin: NA xmax: NA ymax: NA
## geographic CRS: WGS 84

Query 320 : the file exist but is empty

ch2 <- st_read("/Users/nicolas/Documents/R_GitHub/sind/200601 New Polygons final upload/Neil/Neil Tower Workshops/320_146400040_b.gpkg")
## Reading layer `320_146400040_b' from data source `/Users/nicolas/Documents/R_GitHub/sind/200601 New Polygons final upload/Neil/Neil Tower Workshops/320_146400040_b.gpkg' using driver `GPKG'
## Simple feature collection with 0 features and 0 fields
## bbox:           xmin: NA ymin: NA xmax: NA ymax: NA
## geographic CRS: WGS 84

Query 96 : the file exist but FUC = 1780002 not 901780002 .No match

ch3 <- st_read("/Users/nicolas/Documents/R_GitHub/sind/200601 New Polygons final upload/Max/96_901780002_b.gpkg", fid_column_name = "fid")
## Reading layer `96_901780002_b' from data source `/Users/nicolas/Documents/R_GitHub/sind/200601 New Polygons final upload/Max/96_901780002_b.gpkg' using driver `GPKG'
## Simple feature collection with 1 feature and 1 field
## geometry type:  POLYGON
## dimension:      XY
## bbox:           xmin: 532094.2 ymin: 178980.9 xmax: 532106.5 ymax: 179008.4
## projected CRS:  OSGB 1936 / British National Grid
ch3

Query 132 : the file exist but it is incorrectly named thus not read (missing the _b or _B)

ch4 <- st_read("/Users/nicolas/Documents/R_GitHub/sind/200601 New Polygons final upload/Rashi/132_90220001.gpkg", fid_column_name = "fid")
## Reading layer `132_90220001' from data source `/Users/nicolas/Documents/R_GitHub/sind/200601 New Polygons final upload/Rashi/132_90220001.gpkg' using driver `GPKG'
## Simple feature collection with 1 feature and 1 field
## geometry type:  POLYGON
## dimension:      XY
## bbox:           xmin: 532472.6 ymin: 177988 xmax: 532489.1 ymax: 178007.6
## projected CRS:  OSGB 1936 / British National Grid

5 Export CASS survey results

mall <- mall %>%
  select(-fid)
#st_write(mall, "CASS_feb2021.gpkg")
mallcsv <- mall %>%
  st_drop_geometry()
#write_csv(mallcsv, "CASS_feb2021.csv")

6 Combine CASS and OKR data sets

Prepare OKR

okr_sf <- okr %>%
  #select(1:37) %>%
  st_as_sf(., coords = c("Xcoord", "Ycoord"), na.fail = F, crs = 27700) %>%
  filter(Join != 234) %>% # filter point in Australia Join  234.0
  mutate(newFUC = paste0('OKR-', 1:nrow(.)))
## Warning in lapply(x[coords], as.numeric): NAs introduced by coercion

## Warning in lapply(x[coords], as.numeric): NAs introduced by coercion
qtm(okr_sf, fill = "tomato")
## Warning: The shape okr_sf contains empty units.
okr_sf <- okr_sf %>% 
  unique.data.frame()
bind <- bind_rows(mall, okr_sf) %>%
  mutate(U_ID = row_number(),
         source = case_when(is.na(newFUC) ~ "WMT",
                            TRUE ~ "CASS"))
## New names:
## * ...40 -> ...38
## * ...41 -> ...39
## * ...42 -> ...40
## * ...43 -> ...41
## * ...44 -> ...42
## * ...

7 Export results

#st_write(bind, "result_feb2021.gpkg", append=FALSE)
#st_write(bind, "result_feb2021.geojson", append=FALSE)
#write_xlsx(bind, path = "result_feb2021.xlsx", col_names = TRUE)